{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 基金经理名单"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys\n",
    "sys.path.append('..')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "from settings import DBSelector"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "db = DBSelector()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['__class__',\n",
       " '__delattr__',\n",
       " '__dict__',\n",
       " '__dir__',\n",
       " '__doc__',\n",
       " '__eq__',\n",
       " '__format__',\n",
       " '__ge__',\n",
       " '__getattribute__',\n",
       " '__gt__',\n",
       " '__hash__',\n",
       " '__init__',\n",
       " '__init_subclass__',\n",
       " '__le__',\n",
       " '__lt__',\n",
       " '__module__',\n",
       " '__ne__',\n",
       " '__new__',\n",
       " '__reduce__',\n",
       " '__reduce_ex__',\n",
       " '__repr__',\n",
       " '__setattr__',\n",
       " '__sizeof__',\n",
       " '__str__',\n",
       " '__subclasshook__',\n",
       " '__weakref__',\n",
       " 'config',\n",
       " 'get_engine',\n",
       " 'get_mysql_conn',\n",
       " 'json_data']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dir(db)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = db.get_engine('db_fund','qq')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_sql('2020-09-04morning',engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "query = 'select `基金简称`,`最新规模-万`,`累计净值`,`管理人名称` from `2020-09-04morning`'\n",
    "cursor.execute(query)\n",
    "ret = cursor.fetchall()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>基金代码</th>\n",
       "      <th>基金简称</th>\n",
       "      <th>最新规模-万</th>\n",
       "      <th>实时价格</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>成交额-万</th>\n",
       "      <th>净值日期</th>\n",
       "      <th>单位净值</th>\n",
       "      <th>累计净值</th>\n",
       "      <th>折溢价率</th>\n",
       "      <th>申购状态</th>\n",
       "      <th>申赎状态</th>\n",
       "      <th>基金经理</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>管理人名称</th>\n",
       "      <th>实时估值</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>实时净值</th>\n",
       "      <th>溢价率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>160105</td>\n",
       "      <td>南方积极配置混合(LOF)</td>\n",
       "      <td>82110.4</td>\n",
       "      <td>1.354</td>\n",
       "      <td>1.20</td>\n",
       "      <td>12.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.3093</td>\n",
       "      <td>3.4509</td>\n",
       "      <td>3.414040</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>张原、张延闽</td>\n",
       "      <td>2004-10-14</td>\n",
       "      <td>南方基金管理股份有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:26</td>\n",
       "      <td>1.3110</td>\n",
       "      <td>3.180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>160106</td>\n",
       "      <td>南方高增长混合(LOF)</td>\n",
       "      <td>221113.0</td>\n",
       "      <td>1.830</td>\n",
       "      <td>-0.92</td>\n",
       "      <td>52.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.8296</td>\n",
       "      <td>4.3756</td>\n",
       "      <td>0.021863</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>张原</td>\n",
       "      <td>2005-07-13</td>\n",
       "      <td>南方基金管理股份有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:49</td>\n",
       "      <td>1.8490</td>\n",
       "      <td>-1.040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>160119</td>\n",
       "      <td>南方中证500ETF联接(LOF)A</td>\n",
       "      <td>1019760.0</td>\n",
       "      <td>1.715</td>\n",
       "      <td>-0.52</td>\n",
       "      <td>205.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.7219</td>\n",
       "      <td>1.8219</td>\n",
       "      <td>-0.400720</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>罗文杰</td>\n",
       "      <td>2009-09-25</td>\n",
       "      <td>南方基金管理股份有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:40</td>\n",
       "      <td>1.7216</td>\n",
       "      <td>-0.380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>160125</td>\n",
       "      <td>南方香港优选股票(QDII-LOF)</td>\n",
       "      <td>44264.8</td>\n",
       "      <td>1.388</td>\n",
       "      <td>0.14</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>1.3727</td>\n",
       "      <td>1.4627</td>\n",
       "      <td>1.114590</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>毕凯</td>\n",
       "      <td>2011-09-26</td>\n",
       "      <td>南方基金管理股份有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:31</td>\n",
       "      <td>1.3730</td>\n",
       "      <td>1.115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>160128</td>\n",
       "      <td>南方金利A</td>\n",
       "      <td>23537.9</td>\n",
       "      <td>1.001</td>\n",
       "      <td>-0.20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.0120</td>\n",
       "      <td>1.5530</td>\n",
       "      <td>-1.086960</td>\n",
       "      <td>暂停</td>\n",
       "      <td>暂停</td>\n",
       "      <td>李璇</td>\n",
       "      <td>2012-05-17</td>\n",
       "      <td>南方基金管理股份有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:37</td>\n",
       "      <td>1.0119</td>\n",
       "      <td>-1.090</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     基金代码                基金简称     最新规模-万   实时价格   涨跌幅  ...           管理人名称 实时估值                 更新时间    实时净值    溢价率\n",
       "0  160105       南方积极配置混合(LOF)    82110.4  1.354  1.20  ...    南方基金管理股份有限公司    1  2020-09-04 08:35:26  1.3110  3.180\n",
       "1  160106        南方高增长混合(LOF)   221113.0  1.830 -0.92  ...    南方基金管理股份有限公司    1  2020-09-04 08:35:49  1.8490 -1.040\n",
       "2  160119  南方中证500ETF联接(LOF)A  1019760.0  1.715 -0.52  ...    南方基金管理股份有限公司    1  2020-09-04 08:35:40  1.7216 -0.380\n",
       "3  160125  南方香港优选股票(QDII-LOF)    44264.8  1.388  0.14  ...    南方基金管理股份有限公司    0  2020-09-04 08:35:31  1.3730  1.115\n",
       "4  160128               南方金利A    23537.9  1.001 -0.20  ...    南方基金管理股份有限公司    1  2020-09-04 08:35:37  1.0119 -1.090\n",
       "\n",
       "[5 rows x 19 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "sort_df = df.sort_values('累计净值',ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>基金代码</th>\n",
       "      <th>基金简称</th>\n",
       "      <th>最新规模-万</th>\n",
       "      <th>实时价格</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>成交额-万</th>\n",
       "      <th>净值日期</th>\n",
       "      <th>单位净值</th>\n",
       "      <th>累计净值</th>\n",
       "      <th>折溢价率</th>\n",
       "      <th>申购状态</th>\n",
       "      <th>申赎状态</th>\n",
       "      <th>基金经理</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>管理人名称</th>\n",
       "      <th>实时估值</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>实时净值</th>\n",
       "      <th>溢价率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>163402</td>\n",
       "      <td>兴全趋势投资混合(LOF)</td>\n",
       "      <td>2415290.0</td>\n",
       "      <td>0.940</td>\n",
       "      <td>-1.05</td>\n",
       "      <td>6801.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>0.9367</td>\n",
       "      <td>10.9606</td>\n",
       "      <td>0.352301</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>董承非、童兰</td>\n",
       "      <td>2005-11-03</td>\n",
       "      <td>兴证全球基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:49</td>\n",
       "      <td>0.9365</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>160314</td>\n",
       "      <td>华夏行业混合(LOF)</td>\n",
       "      <td>321265.0</td>\n",
       "      <td>1.626</td>\n",
       "      <td>-1.45</td>\n",
       "      <td>59.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.6310</td>\n",
       "      <td>8.3750</td>\n",
       "      <td>-0.306560</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>王劲松</td>\n",
       "      <td>2007-11-22</td>\n",
       "      <td>华夏基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:51</td>\n",
       "      <td>1.6325</td>\n",
       "      <td>-0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>160918</td>\n",
       "      <td>大成中小盘混合(LOF)</td>\n",
       "      <td>118532.0</td>\n",
       "      <td>3.536</td>\n",
       "      <td>-0.95</td>\n",
       "      <td>53.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>3.5190</td>\n",
       "      <td>6.6840</td>\n",
       "      <td>0.483092</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>魏庆国</td>\n",
       "      <td>2014-04-10</td>\n",
       "      <td>大成基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:49</td>\n",
       "      <td>3.5151</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>160311</td>\n",
       "      <td>华夏蓝筹混合(LOF)</td>\n",
       "      <td>436404.0</td>\n",
       "      <td>2.144</td>\n",
       "      <td>-0.37</td>\n",
       "      <td>50.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>2.1460</td>\n",
       "      <td>6.5080</td>\n",
       "      <td>-0.093197</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>王怡欢</td>\n",
       "      <td>2007-04-24</td>\n",
       "      <td>华夏基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:39</td>\n",
       "      <td>2.1557</td>\n",
       "      <td>-0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>161005</td>\n",
       "      <td>富国天惠成长混合(LOF)A</td>\n",
       "      <td>1582680.0</td>\n",
       "      <td>3.391</td>\n",
       "      <td>-0.62</td>\n",
       "      <td>6161.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>3.3732</td>\n",
       "      <td>6.2712</td>\n",
       "      <td>0.527689</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>朱少醒</td>\n",
       "      <td>2005-11-16</td>\n",
       "      <td>富国基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:43</td>\n",
       "      <td>3.3796</td>\n",
       "      <td>0.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>160505</td>\n",
       "      <td>博时主题行业混合(LOF)</td>\n",
       "      <td>1073540.0</td>\n",
       "      <td>1.895</td>\n",
       "      <td>-0.63</td>\n",
       "      <td>321.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.9120</td>\n",
       "      <td>6.0050</td>\n",
       "      <td>-0.889121</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>王俊、金晟哲</td>\n",
       "      <td>2005-01-06</td>\n",
       "      <td>博时基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:44</td>\n",
       "      <td>1.9094</td>\n",
       "      <td>-0.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>163412</td>\n",
       "      <td>兴全轻资产混合(LOF)</td>\n",
       "      <td>837628.0</td>\n",
       "      <td>3.269</td>\n",
       "      <td>-0.46</td>\n",
       "      <td>289.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>3.2860</td>\n",
       "      <td>5.8500</td>\n",
       "      <td>-0.517346</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>董理</td>\n",
       "      <td>2012-04-05</td>\n",
       "      <td>兴证全球基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:40</td>\n",
       "      <td>3.2790</td>\n",
       "      <td>-0.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>160607</td>\n",
       "      <td>鹏华价值优势混合(LOF)</td>\n",
       "      <td>297224.0</td>\n",
       "      <td>1.276</td>\n",
       "      <td>-0.55</td>\n",
       "      <td>82.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.2660</td>\n",
       "      <td>5.7250</td>\n",
       "      <td>0.789889</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>谢书英</td>\n",
       "      <td>2006-07-18</td>\n",
       "      <td>鹏华基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:43</td>\n",
       "      <td>1.2638</td>\n",
       "      <td>0.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>160812</td>\n",
       "      <td>长盛同益成长回报(LOF)</td>\n",
       "      <td>28314.5</td>\n",
       "      <td>2.370</td>\n",
       "      <td>0.04</td>\n",
       "      <td>61.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>2.3710</td>\n",
       "      <td>5.6860</td>\n",
       "      <td>-0.042176</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>张谊然(休产假)、乔培涛(代理)</td>\n",
       "      <td>2014-04-04</td>\n",
       "      <td>长盛基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:31</td>\n",
       "      <td>2.3713</td>\n",
       "      <td>-0.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>162605</td>\n",
       "      <td>景顺长城鼎益混合(LOF)</td>\n",
       "      <td>756521.0</td>\n",
       "      <td>2.863</td>\n",
       "      <td>0.63</td>\n",
       "      <td>4093.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>2.8500</td>\n",
       "      <td>5.6410</td>\n",
       "      <td>0.456140</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>刘彦春</td>\n",
       "      <td>2005-03-16</td>\n",
       "      <td>景顺长城基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:27</td>\n",
       "      <td>2.8472</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       基金代码            基金简称     最新规模-万   实时价格   涨跌幅  ...          管理人名称 实时估值                 更新时间    实时净值   溢价率\n",
       "160  163402   兴全趋势投资混合(LOF)  2415290.0  0.940 -1.05  ...   兴证全球基金管理有限公司    1  2020-09-04 08:35:49  0.9365  0.37\n",
       "18   160314     华夏行业混合(LOF)   321265.0  1.626 -1.45  ...     华夏基金管理有限公司    1  2020-09-04 08:35:51  1.6325 -0.40\n",
       "60   160918    大成中小盘混合(LOF)   118532.0  3.536 -0.95  ...     大成基金管理有限公司    1  2020-09-04 08:35:49  3.5151  0.59\n",
       "17   160311     华夏蓝筹混合(LOF)   436404.0  2.144 -0.37  ...     华夏基金管理有限公司    1  2020-09-04 08:35:39  2.1557 -0.55\n",
       "67   161005  富国天惠成长混合(LOF)A  1582680.0  3.391 -0.62  ...     富国基金管理有限公司    1  2020-09-04 08:35:43  3.3796  0.34\n",
       "24   160505   博时主题行业混合(LOF)  1073540.0  1.895 -0.63  ...     博时基金管理有限公司    1  2020-09-04 08:35:44  1.9094 -0.76\n",
       "163  163412    兴全轻资产混合(LOF)   837628.0  3.269 -0.46  ...   兴证全球基金管理有限公司    1  2020-09-04 08:35:40  3.2790 -0.31\n",
       "33   160607   鹏华价值优势混合(LOF)   297224.0  1.276 -0.55  ...     鹏华基金管理有限公司    1  2020-09-04 08:35:43  1.2638  0.96\n",
       "56   160812   长盛同益成长回报(LOF)    28314.5  2.370  0.04  ...     长盛基金管理有限公司    1  2020-09-04 08:35:31  2.3713 -0.05\n",
       "143  162605   景顺长城鼎益混合(LOF)   756521.0  2.863  0.63  ...   景顺长城基金管理有限公司    1  2020-09-04 08:35:27  2.8472  0.55\n",
       "\n",
       "[10 rows x 19 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sort_df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>基金代码</th>\n",
       "      <th>基金简称</th>\n",
       "      <th>最新规模-万</th>\n",
       "      <th>实时价格</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>成交额-万</th>\n",
       "      <th>净值日期</th>\n",
       "      <th>单位净值</th>\n",
       "      <th>累计净值</th>\n",
       "      <th>折溢价率</th>\n",
       "      <th>申购状态</th>\n",
       "      <th>申赎状态</th>\n",
       "      <th>基金经理</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>管理人名称</th>\n",
       "      <th>实时估值</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>实时净值</th>\n",
       "      <th>溢价率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>161728</td>\n",
       "      <td>招商3年封闭运作战略配售混合(LOF)</td>\n",
       "      <td>2762300.0</td>\n",
       "      <td>1.066</td>\n",
       "      <td>0.00</td>\n",
       "      <td>786.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.1176</td>\n",
       "      <td>1.1176</td>\n",
       "      <td>-4.617040</td>\n",
       "      <td>暂停</td>\n",
       "      <td>--</td>\n",
       "      <td>姚飞军、尹晓红、马龙、吴亮谷</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>招商基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:33</td>\n",
       "      <td>1.1180</td>\n",
       "      <td>-4.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>161131</td>\n",
       "      <td>易方达3年封闭战略配售混合(LOF)</td>\n",
       "      <td>2725360.0</td>\n",
       "      <td>1.059</td>\n",
       "      <td>0.28</td>\n",
       "      <td>2972.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.1143</td>\n",
       "      <td>1.1143</td>\n",
       "      <td>-4.962760</td>\n",
       "      <td>开放</td>\n",
       "      <td>暂停</td>\n",
       "      <td>胡剑、纪玲云、付浩</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:30</td>\n",
       "      <td>1.1143</td>\n",
       "      <td>-5.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>163402</td>\n",
       "      <td>兴全趋势投资混合(LOF)</td>\n",
       "      <td>2415290.0</td>\n",
       "      <td>0.940</td>\n",
       "      <td>-1.05</td>\n",
       "      <td>6801.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>0.9367</td>\n",
       "      <td>10.9606</td>\n",
       "      <td>0.352301</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>董承非、童兰</td>\n",
       "      <td>2005-11-03</td>\n",
       "      <td>兴证全球基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:49</td>\n",
       "      <td>0.9365</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>163417</td>\n",
       "      <td>兴全合宜混合(LOF)A</td>\n",
       "      <td>2074530.0</td>\n",
       "      <td>1.727</td>\n",
       "      <td>-1.43</td>\n",
       "      <td>13411.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.7268</td>\n",
       "      <td>1.7268</td>\n",
       "      <td>0.011582</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>谢治宇</td>\n",
       "      <td>2018-01-23</td>\n",
       "      <td>兴证全球基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:51</td>\n",
       "      <td>1.7325</td>\n",
       "      <td>-0.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>160142</td>\n",
       "      <td>南方3年封闭运作战略配售混合(LOF)</td>\n",
       "      <td>2024200.0</td>\n",
       "      <td>1.065</td>\n",
       "      <td>0.09</td>\n",
       "      <td>1437.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.1176</td>\n",
       "      <td>1.1176</td>\n",
       "      <td>-4.706510</td>\n",
       "      <td>暂停</td>\n",
       "      <td>--</td>\n",
       "      <td>李璇、茅炜</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>南方基金管理股份有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:31</td>\n",
       "      <td>1.1176</td>\n",
       "      <td>-4.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>160706</td>\n",
       "      <td>嘉实沪深300ETF联接(LOF)A</td>\n",
       "      <td>1902520.0</td>\n",
       "      <td>1.351</td>\n",
       "      <td>-0.59</td>\n",
       "      <td>322.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.3588</td>\n",
       "      <td>3.2801</td>\n",
       "      <td>-0.574036</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>何如、陈正宪</td>\n",
       "      <td>2005-08-29</td>\n",
       "      <td>嘉实基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:43</td>\n",
       "      <td>1.3584</td>\n",
       "      <td>-0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>501188</td>\n",
       "      <td>汇添富3年封闭运作战略配售混合(LOF)</td>\n",
       "      <td>1715490.0</td>\n",
       "      <td>1.129</td>\n",
       "      <td>0.18</td>\n",
       "      <td>1370.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.1817</td>\n",
       "      <td>1.1817</td>\n",
       "      <td>-4.459680</td>\n",
       "      <td>暂停</td>\n",
       "      <td>--</td>\n",
       "      <td>刘伟林、何旻、杨瑨、刘江</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>汇添富基金管理股份有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:31</td>\n",
       "      <td>1.1811</td>\n",
       "      <td>-4.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>162703</td>\n",
       "      <td>广发小盘成长混合(LOF)A</td>\n",
       "      <td>1639330.0</td>\n",
       "      <td>3.244</td>\n",
       "      <td>-0.80</td>\n",
       "      <td>2232.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>3.2586</td>\n",
       "      <td>5.5966</td>\n",
       "      <td>-0.448045</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>刘格菘</td>\n",
       "      <td>2005-02-02</td>\n",
       "      <td>广发基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:45</td>\n",
       "      <td>3.2649</td>\n",
       "      <td>-0.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>161005</td>\n",
       "      <td>富国天惠成长混合(LOF)A</td>\n",
       "      <td>1582680.0</td>\n",
       "      <td>3.391</td>\n",
       "      <td>-0.62</td>\n",
       "      <td>6161.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>3.3732</td>\n",
       "      <td>6.2712</td>\n",
       "      <td>0.527689</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>朱少醒</td>\n",
       "      <td>2005-11-16</td>\n",
       "      <td>富国基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:43</td>\n",
       "      <td>3.3796</td>\n",
       "      <td>0.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>161903</td>\n",
       "      <td>万家行业优选混合(LOF)</td>\n",
       "      <td>1349920.0</td>\n",
       "      <td>1.912</td>\n",
       "      <td>-0.57</td>\n",
       "      <td>2890.0</td>\n",
       "      <td>2020-09-03</td>\n",
       "      <td>1.9269</td>\n",
       "      <td>4.9327</td>\n",
       "      <td>-0.773263</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>黄兴亮</td>\n",
       "      <td>2005-07-15</td>\n",
       "      <td>万家基金管理有限公司</td>\n",
       "      <td>1</td>\n",
       "      <td>2020-09-04 08:35:43</td>\n",
       "      <td>1.9305</td>\n",
       "      <td>-0.97</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       基金代码                  基金简称     最新规模-万   实时价格   涨跌幅  ...           管理人名称 实时估值                 更新时间    实时净值   溢价率\n",
       "117  161728   招商3年封闭运作战略配售混合(LOF)  2762300.0  1.066  0.00  ...      招商基金管理有限公司    1  2020-09-04 08:35:33  1.1180 -4.88\n",
       "91   161131    易方达3年封闭战略配售混合(LOF)  2725360.0  1.059  0.28  ...     易方达基金管理有限公司    1  2020-09-04 08:35:30  1.1143 -5.22\n",
       "160  163402         兴全趋势投资混合(LOF)  2415290.0  0.940 -1.05  ...    兴证全球基金管理有限公司    1  2020-09-04 08:35:49  0.9365  0.37\n",
       "165  163417          兴全合宜混合(LOF)A  2074530.0  1.727 -1.43  ...    兴证全球基金管理有限公司    1  2020-09-04 08:35:51  1.7325 -0.32\n",
       "9    160142   南方3年封闭运作战略配售混合(LOF)  2024200.0  1.065  0.09  ...    南方基金管理股份有限公司    1  2020-09-04 08:35:31  1.1176 -4.94\n",
       "47   160706    嘉实沪深300ETF联接(LOF)A  1902520.0  1.351 -0.59  ...      嘉实基金管理有限公司    1  2020-09-04 08:35:43  1.3584 -0.55\n",
       "293  501188  汇添富3年封闭运作战略配售混合(LOF)  1715490.0  1.129  0.18  ...   汇添富基金管理股份有限公司    1  2020-09-04 08:35:31  1.1811 -4.61\n",
       "145  162703        广发小盘成长混合(LOF)A  1639330.0  3.244 -0.80  ...      广发基金管理有限公司    1  2020-09-04 08:35:45  3.2649 -0.64\n",
       "67   161005        富国天惠成长混合(LOF)A  1582680.0  3.391 -0.62  ...      富国基金管理有限公司    1  2020-09-04 08:35:43  3.3796  0.34\n",
       "125  161903         万家行业优选混合(LOF)  1349920.0  1.912 -0.57  ...      万家基金管理有限公司    1  2020-09-04 08:35:43  1.9305 -0.97\n",
       "\n",
       "[10 rows x 19 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values('最新规模-万',ascending=False).head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "manager = df['基金经理'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "317"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(manager)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "name_list =[]\n",
    "for i in manager:\n",
    "    name_list.extend(i.strip().split('、'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "401"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(name_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "count_dict ={}\n",
    "for i in name_list:\n",
    "    count_dict.setdefault(i,0)\n",
    "    count_dict[i]+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'张原': 2,\n",
       " '张延闽': 1,\n",
       " '罗文杰': 2,\n",
       " '毕凯': 1,\n",
       " '李璇': 2,\n",
       " '刘文良': 1,\n",
       " '李慧鹏': 1,\n",
       " '蒋秋洁': 1,\n",
       " '黄亮': 2,\n",
       " '茅炜': 1,\n",
       " '杨飞': 2,\n",
       " '徐治彪': 1,\n",
       " '吴向军': 2,\n",
       " '樊利安': 2,\n",
       " '徐成城': 1,\n",
       " '谢东旭': 1,\n",
       " '王怡欢': 1,\n",
       " '王劲松': 1,\n",
       " '李湘杰': 1,\n",
       " '黄芳': 1,\n",
       " '张城源': 2,\n",
       " '董阳阳': 1,\n",
       " '孙晨进': 1,\n",
       " '马丁': 1,\n",
       " '倪斌': 1,\n",
       " '王俊': 2,\n",
       " '金晟哲': 2,\n",
       " '王增财': 1,\n",
       " '邓欣雨': 1,\n",
       " '程卓': 1,\n",
       " '赵云阳': 1,\n",
       " '陈伟': 1,\n",
       " '张锦': 1,\n",
       " '李洋': 1,\n",
       " '谢书英': 2,\n",
       " '张航': 1,\n",
       " '陈璇淼': 1,\n",
       " '伍旋': 1,\n",
       " '张羽翔': 5,\n",
       " '刘太阳': 1,\n",
       " '祝松': 1,\n",
       " '戴钢': 1,\n",
       " '王石千': 1,\n",
       " '罗捷': 1,\n",
       " '陈龙': 1,\n",
       " '尤柏年': 2,\n",
       " '顾柔刚': 1,\n",
       " '何如': 3,\n",
       " '陈正宪': 4,\n",
       " '高峰': 2,\n",
       " '方晗': 1,\n",
       " '王汉博': 1,\n",
       " '蒋一茜': 1,\n",
       " '刘志刚': 1,\n",
       " '乔培涛': 1,\n",
       " '朱律': 1,\n",
       " '陈亘斯': 5,\n",
       " '张谊然(休产假)': 1,\n",
       " '乔培涛(代理)': 1,\n",
       " '郭堃': 1,\n",
       " '刘旭': 1,\n",
       " '侯春燕': 1,\n",
       " '戴军': 2,\n",
       " '魏庆国': 1,\n",
       " '李林益': 1,\n",
       " '冉凌浩': 3,\n",
       " '王阡': 1,\n",
       " '朱少醒': 1,\n",
       " '武磊': 2,\n",
       " '张明凯': 1,\n",
       " '俞晓斌': 1,\n",
       " '李笑薇': 1,\n",
       " '徐幼华': 2,\n",
       " '方旻': 3,\n",
       " '王保合': 1,\n",
       " '张圣贤': 2,\n",
       " '牛志冬': 3,\n",
       " '蔡卡尔': 2,\n",
       " '胡剑': 2,\n",
       " '周宇': 1,\n",
       " '刘树荣': 4,\n",
       " '王晓晨(休产假)': 1,\n",
       " '纪玲云(代理)': 1,\n",
       " '范冰': 6,\n",
       " '成曦': 1,\n",
       " '纪玲云': 1,\n",
       " '付浩': 1,\n",
       " '赵建': 3,\n",
       " '徐栋': 1,\n",
       " '殷瑞飞': 1,\n",
       " '孙文龙': 1,\n",
       " '綦缚鹏': 1,\n",
       " '王鹏': 1,\n",
       " '吴潇': 3,\n",
       " '邹立虎': 1,\n",
       " '汤海波': 1,\n",
       " '何晶': 1,\n",
       " '蔡志伟': 1,\n",
       " '邹曦': 1,\n",
       " '何龙': 1,\n",
       " '王超': 1,\n",
       " '余志勇': 1,\n",
       " '朱浩然': 1,\n",
       " '何天翔': 1,\n",
       " '贾成东': 1,\n",
       " '向霈': 1,\n",
       " '白海峰': 1,\n",
       " '侯昊': 1,\n",
       " '刘万锋': 1,\n",
       " '张西林': 1,\n",
       " '姚飞军': 3,\n",
       " '尹晓红': 1,\n",
       " '马龙': 1,\n",
       " '吴亮谷': 1,\n",
       " '刘辉': 1,\n",
       " '张凯': 1,\n",
       " '马君': 1,\n",
       " '李宜璇': 2,\n",
       " '邹维娜': 1,\n",
       " '瞿灿': 1,\n",
       " '乐育涛': 1,\n",
       " '王海峰': 2,\n",
       " '黄兴亮': 1,\n",
       " '杨坤': 1,\n",
       " '陈佳昀': 1,\n",
       " '莫海波': 1,\n",
       " '陈良栋': 1,\n",
       " '林龙军': 1,\n",
       " '乔春': 1,\n",
       " '戴骏': 1,\n",
       " '吴华': 1,\n",
       " '杜磊': 1,\n",
       " '刘洋': 2,\n",
       " '刘欣': 1,\n",
       " '江勇': 1,\n",
       " '周晶': 6,\n",
       " '林昊': 1,\n",
       " '黄欣': 1,\n",
       " '沈丹': 1,\n",
       " '刘彦春': 1,\n",
       " '韩文强': 1,\n",
       " '刘格菘': 1,\n",
       " '刘杰': 3,\n",
       " '代宇': 1,\n",
       " '罗国庆': 2,\n",
       " '谢军': 1,\n",
       " '田文舟': 1,\n",
       " '左金保': 1,\n",
       " '宋海岸': 1,\n",
       " '张文琍': 1,\n",
       " '倪伟': 1,\n",
       " '刘婧': 1,\n",
       " '俞诚': 1,\n",
       " '王赟杰': 1,\n",
       " '宋青': 1,\n",
       " '梅律吾': 1,\n",
       " '徐达': 1,\n",
       " '董承非': 1,\n",
       " '童兰': 1,\n",
       " '申庆': 1,\n",
       " '邹欣': 1,\n",
       " '董理': 1,\n",
       " '乔迁': 1,\n",
       " '谢治宇': 1,\n",
       " '许家涵': 1,\n",
       " '王帅': 1,\n",
       " '奚鹏洲': 1,\n",
       " '周毅': 1,\n",
       " '赵建忠': 1,\n",
       " '陈玮': 1,\n",
       " '范锐': 1,\n",
       " '邵强': 1,\n",
       " '尹培俊': 1,\n",
       " '杜广': 1,\n",
       " '姜晓丽': 1,\n",
       " '吴国清': 1,\n",
       " '石峰': 1,\n",
       " '张志强': 1,\n",
       " '刘怡敏': 1,\n",
       " '陈东(休假)': 1,\n",
       " '朱向临': 1,\n",
       " '赖中立': 6,\n",
       " '陆文磊': 1,\n",
       " '徐光': 1,\n",
       " '胡娜': 1,\n",
       " '何秀红（休产假）': 1,\n",
       " '欧阳凯（代理）': 1,\n",
       " '郭雪松（代理）': 1,\n",
       " '刘伟琳': 2,\n",
       " '张洋': 1,\n",
       " '李昱': 1,\n",
       " '唐赟': 1,\n",
       " '蔡铮': 2,\n",
       " '梁洪昀': 2,\n",
       " '李峰': 1,\n",
       " '姜锋': 1,\n",
       " '吴尚伟': 1,\n",
       " '夏明月': 1,\n",
       " '宋海娟': 1,\n",
       " '顾凡丁': 2,\n",
       " '吴昊': 4,\n",
       " '张弘': 1,\n",
       " '杨立春': 2,\n",
       " '韩海平': 1,\n",
       " '黄稚(休假)': 1,\n",
       " 'HANYILING(代理)': 1,\n",
       " '提云涛': 1,\n",
       " '郑伟': 1,\n",
       " '江峰': 1,\n",
       " '周蔚文': 2,\n",
       " '王培': 1,\n",
       " '洪慧梅': 2,\n",
       " '张明': 3,\n",
       " '王健': 1,\n",
       " '许文星': 1,\n",
       " '魏博': 1,\n",
       " '华李成': 1,\n",
       " '尹华龙': 1,\n",
       " '王咏辉': 2,\n",
       " '章潇枫': 1,\n",
       " '陈士俊': 1,\n",
       " '王剑': 1,\n",
       " '胡振仓': 1,\n",
       " '刘俊廷': 3,\n",
       " '张俊生': 2,\n",
       " '苏宁': 1,\n",
       " '庄园': 1,\n",
       " '张翼飞': 1,\n",
       " '李君': 1,\n",
       " '徐黄玮': 1,\n",
       " '施荣盛': 1,\n",
       " '陈一峰': 1,\n",
       " '王本昌': 2,\n",
       " '吴坚': 1,\n",
       " '刘开运': 3,\n",
       " '张鹏程': 1,\n",
       " '林柏川': 1,\n",
       " '胡德军': 1,\n",
       " '朱然': 1,\n",
       " '盖俊龙': 1,\n",
       " '潘天奇': 1,\n",
       " '韩冬': 1,\n",
       " '孙伟': 1,\n",
       " '李响': 1,\n",
       " '周杨': 1,\n",
       " '张伟锋': 1,\n",
       " '马斌博': 1,\n",
       " '宫雪': 3,\n",
       " '梁辰': 1,\n",
       " '吴振翔': 5,\n",
       " '过蓓蓓': 6,\n",
       " '谈洁颖': 1,\n",
       " '艾小军': 2,\n",
       " '聂毅翔': 1,\n",
       " '夏钦': 3,\n",
       " '戴计辉': 1,\n",
       " '胡洁': 4,\n",
       " '刘伟林': 3,\n",
       " '曾刚': 2,\n",
       " '胡奕': 2,\n",
       " '董瑾': 4,\n",
       " '荣膺': 1,\n",
       " '李明阳': 1,\n",
       " '邹维': 1,\n",
       " '盛丰衍': 2,\n",
       " '魏孛': 2,\n",
       " '史博': 1,\n",
       " '苏燕青(休产假)': 2,\n",
       " '刘重杰(代理)': 2,\n",
       " '刘明宇': 1,\n",
       " '何旻': 1,\n",
       " '杨瑨': 1,\n",
       " '刘江': 1,\n",
       " '刘宁': 1,\n",
       " '王鑫晨': 1,\n",
       " '谭丽': 1,\n",
       " '陆丛凡': 1,\n",
       " '楼华锋': 1,\n",
       " '陈伯祯': 1,\n",
       " '刘珈吟': 1,\n",
       " '余海燕': 4,\n",
       " '苏秉毅': 1,\n",
       " '夏高': 1}"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "count_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "sort_name = list(sorted(count_dict.items(),key=lambda x:x[1],reverse=True))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('范冰', 6),\n",
       " ('周晶', 6),\n",
       " ('赖中立', 6),\n",
       " ('过蓓蓓', 6),\n",
       " ('张羽翔', 5),\n",
       " ('陈亘斯', 5),\n",
       " ('吴振翔', 5),\n",
       " ('陈正宪', 4),\n",
       " ('刘树荣', 4),\n",
       " ('吴昊', 4),\n",
       " ('胡洁', 4),\n",
       " ('董瑾', 4),\n",
       " ('余海燕', 4),\n",
       " ('何如', 3),\n",
       " ('冉凌浩', 3),\n",
       " ('方旻', 3),\n",
       " ('牛志冬', 3),\n",
       " ('赵建', 3),\n",
       " ('吴潇', 3),\n",
       " ('姚飞军', 3),\n",
       " ('刘杰', 3),\n",
       " ('张明', 3),\n",
       " ('刘俊廷', 3),\n",
       " ('刘开运', 3),\n",
       " ('宫雪', 3),\n",
       " ('夏钦', 3),\n",
       " ('刘伟林', 3),\n",
       " ('张原', 2),\n",
       " ('罗文杰', 2),\n",
       " ('李璇', 2),\n",
       " ('黄亮', 2),\n",
       " ('杨飞', 2),\n",
       " ('吴向军', 2),\n",
       " ('樊利安', 2),\n",
       " ('张城源', 2),\n",
       " ('王俊', 2),\n",
       " ('金晟哲', 2),\n",
       " ('谢书英', 2),\n",
       " ('尤柏年', 2),\n",
       " ('高峰', 2),\n",
       " ('戴军', 2),\n",
       " ('武磊', 2),\n",
       " ('徐幼华', 2),\n",
       " ('张圣贤', 2),\n",
       " ('蔡卡尔', 2),\n",
       " ('胡剑', 2),\n",
       " ('李宜璇', 2),\n",
       " ('王海峰', 2),\n",
       " ('刘洋', 2),\n",
       " ('罗国庆', 2),\n",
       " ('刘伟琳', 2),\n",
       " ('蔡铮', 2),\n",
       " ('梁洪昀', 2),\n",
       " ('顾凡丁', 2),\n",
       " ('杨立春', 2),\n",
       " ('周蔚文', 2),\n",
       " ('洪慧梅', 2),\n",
       " ('王咏辉', 2),\n",
       " ('张俊生', 2),\n",
       " ('王本昌', 2),\n",
       " ('艾小军', 2),\n",
       " ('曾刚', 2),\n",
       " ('胡奕', 2),\n",
       " ('盛丰衍', 2),\n",
       " ('魏孛', 2),\n",
       " ('苏燕青(休产假)', 2),\n",
       " ('刘重杰(代理)', 2),\n",
       " ('张延闽', 1),\n",
       " ('毕凯', 1),\n",
       " ('刘文良', 1),\n",
       " ('李慧鹏', 1),\n",
       " ('蒋秋洁', 1),\n",
       " ('茅炜', 1),\n",
       " ('徐治彪', 1),\n",
       " ('徐成城', 1),\n",
       " ('谢东旭', 1),\n",
       " ('王怡欢', 1),\n",
       " ('王劲松', 1),\n",
       " ('李湘杰', 1),\n",
       " ('黄芳', 1),\n",
       " ('董阳阳', 1),\n",
       " ('孙晨进', 1),\n",
       " ('马丁', 1),\n",
       " ('倪斌', 1),\n",
       " ('王增财', 1),\n",
       " ('邓欣雨', 1),\n",
       " ('程卓', 1),\n",
       " ('赵云阳', 1),\n",
       " ('陈伟', 1),\n",
       " ('张锦', 1),\n",
       " ('李洋', 1),\n",
       " ('张航', 1),\n",
       " ('陈璇淼', 1),\n",
       " ('伍旋', 1),\n",
       " ('刘太阳', 1),\n",
       " ('祝松', 1),\n",
       " ('戴钢', 1),\n",
       " ('王石千', 1),\n",
       " ('罗捷', 1),\n",
       " ('陈龙', 1),\n",
       " ('顾柔刚', 1),\n",
       " ('方晗', 1),\n",
       " ('王汉博', 1),\n",
       " ('蒋一茜', 1),\n",
       " ('刘志刚', 1),\n",
       " ('乔培涛', 1),\n",
       " ('朱律', 1),\n",
       " ('张谊然(休产假)', 1),\n",
       " ('乔培涛(代理)', 1),\n",
       " ('郭堃', 1),\n",
       " ('刘旭', 1),\n",
       " ('侯春燕', 1),\n",
       " ('魏庆国', 1),\n",
       " ('李林益', 1),\n",
       " ('王阡', 1),\n",
       " ('朱少醒', 1),\n",
       " ('张明凯', 1),\n",
       " ('俞晓斌', 1),\n",
       " ('李笑薇', 1),\n",
       " ('王保合', 1),\n",
       " ('周宇', 1),\n",
       " ('王晓晨(休产假)', 1),\n",
       " ('纪玲云(代理)', 1),\n",
       " ('成曦', 1),\n",
       " ('纪玲云', 1),\n",
       " ('付浩', 1),\n",
       " ('徐栋', 1),\n",
       " ('殷瑞飞', 1),\n",
       " ('孙文龙', 1),\n",
       " ('綦缚鹏', 1),\n",
       " ('王鹏', 1),\n",
       " ('邹立虎', 1),\n",
       " ('汤海波', 1),\n",
       " ('何晶', 1),\n",
       " ('蔡志伟', 1),\n",
       " ('邹曦', 1),\n",
       " ('何龙', 1),\n",
       " ('王超', 1),\n",
       " ('余志勇', 1),\n",
       " ('朱浩然', 1),\n",
       " ('何天翔', 1),\n",
       " ('贾成东', 1),\n",
       " ('向霈', 1),\n",
       " ('白海峰', 1),\n",
       " ('侯昊', 1),\n",
       " ('刘万锋', 1),\n",
       " ('张西林', 1),\n",
       " ('尹晓红', 1),\n",
       " ('马龙', 1),\n",
       " ('吴亮谷', 1),\n",
       " ('刘辉', 1),\n",
       " ('张凯', 1),\n",
       " ('马君', 1),\n",
       " ('邹维娜', 1),\n",
       " ('瞿灿', 1),\n",
       " ('乐育涛', 1),\n",
       " ('黄兴亮', 1),\n",
       " ('杨坤', 1),\n",
       " ('陈佳昀', 1),\n",
       " ('莫海波', 1),\n",
       " ('陈良栋', 1),\n",
       " ('林龙军', 1),\n",
       " ('乔春', 1),\n",
       " ('戴骏', 1),\n",
       " ('吴华', 1),\n",
       " ('杜磊', 1),\n",
       " ('刘欣', 1),\n",
       " ('江勇', 1),\n",
       " ('林昊', 1),\n",
       " ('黄欣', 1),\n",
       " ('沈丹', 1),\n",
       " ('刘彦春', 1),\n",
       " ('韩文强', 1),\n",
       " ('刘格菘', 1),\n",
       " ('代宇', 1),\n",
       " ('谢军', 1),\n",
       " ('田文舟', 1),\n",
       " ('左金保', 1),\n",
       " ('宋海岸', 1),\n",
       " ('张文琍', 1),\n",
       " ('倪伟', 1),\n",
       " ('刘婧', 1),\n",
       " ('俞诚', 1),\n",
       " ('王赟杰', 1),\n",
       " ('宋青', 1),\n",
       " ('梅律吾', 1),\n",
       " ('徐达', 1),\n",
       " ('董承非', 1),\n",
       " ('童兰', 1),\n",
       " ('申庆', 1),\n",
       " ('邹欣', 1),\n",
       " ('董理', 1),\n",
       " ('乔迁', 1),\n",
       " ('谢治宇', 1),\n",
       " ('许家涵', 1),\n",
       " ('王帅', 1),\n",
       " ('奚鹏洲', 1),\n",
       " ('周毅', 1),\n",
       " ('赵建忠', 1),\n",
       " ('陈玮', 1),\n",
       " ('范锐', 1),\n",
       " ('邵强', 1),\n",
       " ('尹培俊', 1),\n",
       " ('杜广', 1),\n",
       " ('姜晓丽', 1),\n",
       " ('吴国清', 1),\n",
       " ('石峰', 1),\n",
       " ('张志强', 1),\n",
       " ('刘怡敏', 1),\n",
       " ('陈东(休假)', 1),\n",
       " ('朱向临', 1),\n",
       " ('陆文磊', 1),\n",
       " ('徐光', 1),\n",
       " ('胡娜', 1),\n",
       " ('何秀红（休产假）', 1),\n",
       " ('欧阳凯（代理）', 1),\n",
       " ('郭雪松（代理）', 1),\n",
       " ('张洋', 1),\n",
       " ('李昱', 1),\n",
       " ('唐赟', 1),\n",
       " ('李峰', 1),\n",
       " ('姜锋', 1),\n",
       " ('吴尚伟', 1),\n",
       " ('夏明月', 1),\n",
       " ('宋海娟', 1),\n",
       " ('张弘', 1),\n",
       " ('韩海平', 1),\n",
       " ('黄稚(休假)', 1),\n",
       " ('HANYILING(代理)', 1),\n",
       " ('提云涛', 1),\n",
       " ('郑伟', 1),\n",
       " ('江峰', 1),\n",
       " ('王培', 1),\n",
       " ('王健', 1),\n",
       " ('许文星', 1),\n",
       " ('魏博', 1),\n",
       " ('华李成', 1),\n",
       " ('尹华龙', 1),\n",
       " ('章潇枫', 1),\n",
       " ('陈士俊', 1),\n",
       " ('王剑', 1),\n",
       " ('胡振仓', 1),\n",
       " ('苏宁', 1),\n",
       " ('庄园', 1),\n",
       " ('张翼飞', 1),\n",
       " ('李君', 1),\n",
       " ('徐黄玮', 1),\n",
       " ('施荣盛', 1),\n",
       " ('陈一峰', 1),\n",
       " ('吴坚', 1),\n",
       " ('张鹏程', 1),\n",
       " ('林柏川', 1),\n",
       " ('胡德军', 1),\n",
       " ('朱然', 1),\n",
       " ('盖俊龙', 1),\n",
       " ('潘天奇', 1),\n",
       " ('韩冬', 1),\n",
       " ('孙伟', 1),\n",
       " ('李响', 1),\n",
       " ('周杨', 1),\n",
       " ('张伟锋', 1),\n",
       " ('马斌博', 1),\n",
       " ('梁辰', 1),\n",
       " ('谈洁颖', 1),\n",
       " ('聂毅翔', 1),\n",
       " ('戴计辉', 1),\n",
       " ('荣膺', 1),\n",
       " ('李明阳', 1),\n",
       " ('邹维', 1),\n",
       " ('史博', 1),\n",
       " ('刘明宇', 1),\n",
       " ('何旻', 1),\n",
       " ('杨瑨', 1),\n",
       " ('刘江', 1),\n",
       " ('刘宁', 1),\n",
       " ('王鑫晨', 1),\n",
       " ('谭丽', 1),\n",
       " ('陆丛凡', 1),\n",
       " ('楼华锋', 1),\n",
       " ('陈伯祯', 1),\n",
       " ('刘珈吟', 1),\n",
       " ('苏秉毅', 1),\n",
       " ('夏高', 1)]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sort_name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>基金代码</th>\n",
       "      <th>基金简称</th>\n",
       "      <th>最新规模-万</th>\n",
       "      <th>实时价格</th>\n",
       "      <th>涨跌幅</th>\n",
       "      <th>成交额-万</th>\n",
       "      <th>净值日期</th>\n",
       "      <th>单位净值</th>\n",
       "      <th>累计净值</th>\n",
       "      <th>折溢价率</th>\n",
       "      <th>申购状态</th>\n",
       "      <th>申赎状态</th>\n",
       "      <th>基金经理</th>\n",
       "      <th>成立日期</th>\n",
       "      <th>管理人名称</th>\n",
       "      <th>实时估值</th>\n",
       "      <th>更新时间</th>\n",
       "      <th>实时净值</th>\n",
       "      <th>溢价率</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>161125</td>\n",
       "      <td>易标普500指数(QDII-LOF)</td>\n",
       "      <td>43073.60</td>\n",
       "      <td>1.581</td>\n",
       "      <td>3.40</td>\n",
       "      <td>441.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>1.5294</td>\n",
       "      <td>1.5294</td>\n",
       "      <td>3.373870</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>范冰、刘树荣</td>\n",
       "      <td>2016-12-02</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:25</td>\n",
       "      <td>1.529</td>\n",
       "      <td>3.374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>161126</td>\n",
       "      <td>易标普医疗保健指数(QDII-LOF)</td>\n",
       "      <td>6061.99</td>\n",
       "      <td>1.526</td>\n",
       "      <td>1.53</td>\n",
       "      <td>49.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>1.5234</td>\n",
       "      <td>1.5234</td>\n",
       "      <td>0.170671</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>范冰</td>\n",
       "      <td>2016-11-28</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:26</td>\n",
       "      <td>1.523</td>\n",
       "      <td>0.171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>161127</td>\n",
       "      <td>易标普生物科技指数(QDII-LOF)</td>\n",
       "      <td>9883.41</td>\n",
       "      <td>1.590</td>\n",
       "      <td>-0.38</td>\n",
       "      <td>25.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>1.5782</td>\n",
       "      <td>1.5782</td>\n",
       "      <td>0.747687</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>范冰</td>\n",
       "      <td>2016-12-13</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:39</td>\n",
       "      <td>1.578</td>\n",
       "      <td>0.748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>161128</td>\n",
       "      <td>易标普信息科技指数(QDII-LOF)</td>\n",
       "      <td>109853.00</td>\n",
       "      <td>2.524</td>\n",
       "      <td>1.94</td>\n",
       "      <td>1674.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2.4148</td>\n",
       "      <td>2.4148</td>\n",
       "      <td>4.522110</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>范冰</td>\n",
       "      <td>2016-12-13</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:26</td>\n",
       "      <td>2.415</td>\n",
       "      <td>4.522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>161129</td>\n",
       "      <td>易原油(QDII-LOF-FOF)A</td>\n",
       "      <td>54247.50</td>\n",
       "      <td>0.605</td>\n",
       "      <td>-0.66</td>\n",
       "      <td>785.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>0.5470</td>\n",
       "      <td>0.5470</td>\n",
       "      <td>10.603300</td>\n",
       "      <td>暂停</td>\n",
       "      <td>开放</td>\n",
       "      <td>范冰、成曦</td>\n",
       "      <td>2016-12-19</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:44</td>\n",
       "      <td>0.547</td>\n",
       "      <td>10.603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>161130</td>\n",
       "      <td>易纳斯达克100指数(QDII-LOF)</td>\n",
       "      <td>73146.10</td>\n",
       "      <td>2.160</td>\n",
       "      <td>1.27</td>\n",
       "      <td>2656.0</td>\n",
       "      <td>2020-09-02</td>\n",
       "      <td>2.0001</td>\n",
       "      <td>2.0001</td>\n",
       "      <td>7.994600</td>\n",
       "      <td>开放</td>\n",
       "      <td>开放</td>\n",
       "      <td>范冰</td>\n",
       "      <td>2017-06-23</td>\n",
       "      <td>易方达基金管理有限公司</td>\n",
       "      <td>0</td>\n",
       "      <td>2020-09-04 08:35:26</td>\n",
       "      <td>2.000</td>\n",
       "      <td>7.995</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      基金代码                  基金简称     最新规模-万   实时价格   涨跌幅   ...          管理人名称 实时估值                 更新时间   实时净值     溢价率\n",
       "85  161125    易标普500指数(QDII-LOF)   43073.60  1.581  3.40   ...    易方达基金管理有限公司    0  2020-09-04 08:35:25  1.529   3.374\n",
       "86  161126   易标普医疗保健指数(QDII-LOF)    6061.99  1.526  1.53   ...    易方达基金管理有限公司    0  2020-09-04 08:35:26  1.523   0.171\n",
       "87  161127   易标普生物科技指数(QDII-LOF)    9883.41  1.590 -0.38   ...    易方达基金管理有限公司    0  2020-09-04 08:35:39  1.578   0.748\n",
       "88  161128   易标普信息科技指数(QDII-LOF)  109853.00  2.524  1.94   ...    易方达基金管理有限公司    0  2020-09-04 08:35:26  2.415   4.522\n",
       "89  161129    易原油(QDII-LOF-FOF)A   54247.50  0.605 -0.66   ...    易方达基金管理有限公司    0  2020-09-04 08:35:44  0.547  10.603\n",
       "90  161130  易纳斯达克100指数(QDII-LOF)   73146.10  2.160  1.27   ...    易方达基金管理有限公司    0  2020-09-04 08:35:26  2.000   7.995\n",
       "\n",
       "[6 rows x 19 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['基金经理'].str.contains('范冰')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3-final"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}